﻿

CREATE VIEW [dbo].[PersoaneVizaCFP]
AS
SELECT     dbo.Persoane.NumePrenume, dbo.ResponsabilVizaCFP.CodUnitate, dbo.ResponsabilVizaCFP.DataActivare, dbo.ResponsabilVizaCFP.IDResponsabil, 
                      dbo.ResponsabilVizaCFP.IDPersoana
FROM         dbo.ResponsabilVizaCFP INNER JOIN
                      dbo.Persoane ON dbo.ResponsabilVizaCFP.IDPersoana = dbo.Persoane.IdPersoana